package com.pig4cloud.pig.common.core.constant;

/**
 * @author Administrator
 */
public interface BpmnConstants {
	String USER_TASK = "userTask";


	String HISTORY_TASK_QUERY_TASK_SQL = """
			SELECT
			    t.ID_,
			    t.TASK_DEF_KEY_,
			    t.PROC_DEF_KEY_,
			    t.PROC_DEF_ID_,
			    t.ROOT_PROC_INST_ID_,
			    t.PROC_INST_ID_,
			    t.EXECUTION_ID_,
			    t.CASE_DEF_KEY_,
			    t.CASE_DEF_ID_,
			    t.CASE_INST_ID_,
			    t.CASE_EXECUTION_ID_,
			    t.ACT_INST_ID_,
			    t.NAME_,
			    t.PARENT_TASK_ID_,
			    t.DESCRIPTION_,
			    t.OWNER_,
			    t.ASSIGNEE_,
			    t.START_TIME_,
			    t.END_TIME_,
			    t.DURATION_,
			    t.DELETE_REASON_,
			    t.PRIORITY_,
			    t.DUE_DATE_,
			    t.FOLLOW_UP_DATE_,
			    t.TENANT_ID_,
			    t.REMOVAL_TIME_,
			    t.TASK_STATE_
			FROM
			    act_hi_taskinst t
			JOIN
			    act_hi_procinst p ON t.PROC_INST_ID_ = p.PROC_INST_ID_
			WHERE
			    t.ASSIGNEE_ = #{assignee}
			    AND p.STATE_ = #{state};
			
			""";
	String DELETED = "deleted";
	String COMPLETED = "completed";
}
